﻿CREATE TABLE [dbo].[DoanVien]
(
	[MaHS] VARCHAR(10) NOT NULL PRIMARY KEY, 
    [Ho] VARCHAR(100) NULL, 
    [Ten] VARCHAR(10) NULL, 
    [NgaySinh] DATETIME NULL, 
    [GioiTinh] BIT NULL DEFAULT 1, 
    [NgayVaoDoan] DATETIME NULL, 
    [DiaChiThuongTru] VARCHAR(MAX) NULL, 
    [DiaChiThuongTru_Phuong] VARCHAR(50) NULL, 
    [DiaCHiThuongTru_Quan] VARCHAR(30) NULL, 
    [DiaChiNoiOHienTai] VARCHAR(MAX) NULL, 
    [DiaChiNoiOHienTai_Phuong] VARCHAR(50) NULL, 
    [DiaChiNoiOHienTai_Quan] VARCHAR(30) NULL, 
    [DienThoaiLienHe] VARCHAR(12) NULL, 
    [MaChiDoan] VARCHAR(3) NULL, 
    [NoiChuyenSinhHoatDen] VARCHAR(MAX) NULL, 
    [NgayChuyenDen] DATETIME NULL, 
    [NoiChuyenSinhHoatDi] VARCHAR(MAX) NULL, 
    [NgayChuyenDi] DATETIME NULL, 
    [TinhTrang] VARCHAR(20) NULL, 
    [PasswordDoanVien] VARCHAR(20) NULL
)
